﻿--工具批注情况
CREATE proc [dbo].[proc_Customer_Subjoin_List_ToolComment]
(
	@departmentid int
)
as
	select 
		ct.id,
		customerid,
		(select c.customername from customer c where c.customerid=ct.customerid) as customername,
		SubjoinId,
		(select title from Customer_Subjoin cs where cs.id=ct.SubjoinId) as subjion,
		[description],
		upname,
		uptime
	
	from 
		Customer_Subjoin_List ct
	where
		    ct.departmentid=@departmentid